SUPPORT / SAMPLES & SAS NOTES
Problem Note 60017: User-defined formats might not be passed to temporary tables in the SAS® LASR™ Analytic Server
 |  |  |  |  |
Temporary tables created by the SAS LASR Analytic Server might not include user-defined formats that are applied to the source tables. This problem is most evident when you create a LASR star schema that contains user-defined formats, and then you use the output in SAS® Visual Analytics Explorer. Specifically, attempting to use a data item with an applied user-defined format might fail with the following error:
ERROR [sasdemo] com.sas.biv.exception.BivException - com.sas.lasr.LASRException: ERROR: The format $FORMAT could not be loaded in the LASR Analytic Server. (errorCode=GENERIC_EXCEPTION, params=null)
java.lang.RuntimeException: com.sas.lasr.LASRException: ERROR: The format $FORMAT could not be loaded in the LASR Analytic Server.
at com.sas.va.data.query.lasr.invoker.impl.LasrInvokerServiceImpl.getException(LasrInvokerServiceImpl.java:1466)
at com.sas.va.data.query.lasr.invoker.impl.LasrInvokerServiceImpl.groupBy(LasrInvokerServiceImpl.java:1142)
at com.sas.va.data.query.dataprovider.lasr.queryrunner.LasrGroupByQueryRunner.runThread(LasrGroupByQueryRunner.java:41)
java.lang.RuntimeException: com.sas.lasr.LASRException: ERROR: The format $FORMAT could not be loaded in the LASR Analytic Server.
at com.sas.va.data.query.lasr.invoker.impl.LasrInvokerServiceImpl.getException(LasrInvokerServiceImpl.java:1466)
at com.sas.va.data.query.lasr.invoker.impl.LasrInvokerServiceImpl.groupBy(LasrInvokerServiceImpl.java:1142)
at com.sas.va.data.query.dataprovider.lasr.queryrunner.LasrGroupByQueryRunner.runThread(LasrGroupByQueryRunner.java:41)
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | Base SAS | Microsoft® Windows® for x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 |
| Microsoft Windows 8 Enterprise 32-bit | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Pro x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 10 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 Std | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Enterprise 32 bit | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Enterprise x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Home Premium 32 bit | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Home Premium x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Professional 32 bit | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Professional x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Ultimate 32 bit | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Ultimate x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| 64-bit Enabled AIX | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| 64-bit Enabled Solaris | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| HP-UX IPF | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Linux for x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Solaris for x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||